﻿CREATE TABLE [dbo].[CompanyProfile] (
    [Id]                 UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
    [FullName]           NVARCHAR (250)   NULL,
    [ShortName]          NVARCHAR (32)    NULL,
    [LawPerson]          NVARCHAR (32)    NULL,
    [Bank]               NVARCHAR (250)   NULL,
    [BankAccount]        NVARCHAR (36)    NULL,
    [LastModifiedTime]   DATETIME         NULL,
    [LastModifiedUserID] UNIQUEIDENTIFIER NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK2F9EF42E11E65B0E] FOREIGN KEY ([LastModifiedUserID]) REFERENCES [dbo].[UserProfile] ([ID])
);

